CREATE PROCEDURE [dbo].[sp_cat_GetPermission]
@Permission varchar(50) = NULL, @PKPermission int = NULL
AS
BEGIN
  SELECT PKPermission , Permission FROM SC_Permission
  WHERE PKPermission = COALESCE(@PKPermission , PKPermission)
  AND Permission = COALESCE(@Permission , Permission)
  ORDER BY Permission;
END